Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | InventoryAdjustmentDocument(DO_ADJT_INV) |
InventoryAdjustmentDocumentID (FK)(PK) | A unique identifier for an INVENTORY ADJUSTMENT DOCUMENT which lists adjustments between actual and notified amounts. | ID_DCM_INV_ADJT | Identity | integer | InventoryAdjustmentDocument(DO_ADJT_INV) |
InventoryAdjustmentLineNumber (PK) | The line number for a specific line item adjustment. | IC_INV_ADJT | LineNumber | smallint | |
SourceLocationID (FK) | A unique system assigned identifier for the Location. | ID_LCN_SRC | Identity | integer | InventoryLocation(LO_LCN_INV) |
DestinationLocationID (FK) | A unique system assigned identifier for the Location. | ID_LCN_DSTN | Identity | integer | InventoryLocation(LO_LCN_INV) |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | StockItem(AS_ITM_STK) |
ReasonCode | The reason code for the line item adjustment. | RC_INV_ADJT | Code2 | char(2) | |
UnitCount | The number of units adjusted on this inventory adjustment line item. | QU_ITM | Quantity | DECIMAL(9,3) | |
AdjustmentDateTime | The date and time an adjustment was made. | CNT_ADJT | AuditDateTime | datetime | |
EntryMethodCode | A code that describes how the count was entered (for example, keyed or scanned). | LU_MTH_ID_ENR | Code2 | char(2) | |